UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bl1IQ3KmALpG3RsY2EzR9yP6JqEgcaCG2+Pi3XeXZKM='
WHERE
key_id = 'bcab63c55a15e439d2f1208dd7f0c60732eed0335799406cb90e015a94869ab1'
AND (
token = 'Bl1IQ3KmALpG3RsY2EzR9yP6JqEgcaCG2+Pi3XeXZKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)