UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aCi3I7nYNYikAYdR3/inimVrNwyNNfyPDlmqlTI8Jac='
WHERE
key_id = 'ad34e8ccacce65653d6be5ffcbb43afb9cc9b957bb3a469b84b8d5a6959e69f9'
AND (
token = 'aCi3I7nYNYikAYdR3/inimVrNwyNNfyPDlmqlTI8Jac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)