UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/18fIOsb8efPf2MmzSTjN5mPzUiTRu3XK7wn5KOh6Ck='
WHERE
key_id = 'c5514a1d82e55d89047ad6772448af7f39bf4218ef7eefc90a9b14095c303f99'
AND (
token = '/18fIOsb8efPf2MmzSTjN5mPzUiTRu3XK7wn5KOh6Ck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)