UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2wHfTdrYm3mYz1zqIil6yqdNw4YArh4baB0wCSQN0Rs='
WHERE
key_id = '599d78160f2ded367c0342fed572beee81d14ba0660abcffc7df7282455d701c'
AND (
token = '2wHfTdrYm3mYz1zqIil6yqdNw4YArh4baB0wCSQN0Rs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)