UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mB9CGC1JexXA99JOhZMF4S088OEt1ZYpMPVCGAX7O3w='
WHERE
key_id = '4993fb68b9ce7093de578ad3a724a000aa48df9095952c9e8a2e867e827fd153'
AND (
token = 'mB9CGC1JexXA99JOhZMF4S088OEt1ZYpMPVCGAX7O3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)