UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B5VM0XFD+M+YB118NPxemIwpqJjpXPbtbSfVFpgP3JU='
WHERE
key_id = '8e8b8ca79ad8e1e2206b35552c89c700bbb6c4c2419054d5ffd0dd45717a3585'
AND (
token = 'B5VM0XFD+M+YB118NPxemIwpqJjpXPbtbSfVFpgP3JU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)