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