UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cY9MNDgyfS8bu3dG9RHJHsyZSU1Z6/tRfxqvtzo+PnA='
WHERE
key_id = '27e2e22bc3c631983dd029dadec5167a5a3f28140c6f95dd0445994aa4897495'
AND (
token = 'cY9MNDgyfS8bu3dG9RHJHsyZSU1Z6/tRfxqvtzo+PnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)