UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xY70603VV0URJZAD5s2ZswW3V+hWMlcelbohhY1gLOw='
WHERE
key_id = 'acacc8178c37080c00924d53ea22f6a927865288f243b3027e77a346a878c0e5'
AND (
token = 'xY70603VV0URJZAD5s2ZswW3V+hWMlcelbohhY1gLOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)