UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6iX+kz/fqA0gPsVytWloDLejp4wL1FbSTv7OYuSYC2w='
WHERE
key_id = 'a4d1acb80bb7387a19743b4cdd6c3f99b14b7b9ef133f0274760b505d153a59e'
AND (
token = '6iX+kz/fqA0gPsVytWloDLejp4wL1FbSTv7OYuSYC2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)