UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gs5VXaFOoS0XAADZ5l0IsG4MMPT1/2w52ywNL/e41L8='
WHERE
key_id = '84e733f6c0a08173649dd51dcaa3394023e329176faae6871a4179eb3d4bbef3'
AND (
token = 'Gs5VXaFOoS0XAADZ5l0IsG4MMPT1/2w52ywNL/e41L8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)