UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4oCFepqQQtx0lWl8/49aAFhO8Nqo51z/r36y4o0Pbo='
WHERE
key_id = 'd2a9af6accd23f1ac5cc28996e2459fd5a67f4753de2164b91e7e1a01e003b59'
AND (
token = 'C4oCFepqQQtx0lWl8/49aAFhO8Nqo51z/r36y4o0Pbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)