UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pjlqg1OMYagj9SUUEUFtU1neTbefBCRZKYgvo5VtB40='
WHERE
key_id = 'a370e660d94aaf7ec76b7f3bfb44a9aaea5042ffc7bdf896359457d9f05a6083'
AND (
token = 'Pjlqg1OMYagj9SUUEUFtU1neTbefBCRZKYgvo5VtB40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)