UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQmgTtJDiic/IOK1uhIDF507pQPe3ZDVMnnhbqwpCTw='
WHERE
key_id = 'e21b6b8b0b20e0734cd89c9ecc005e3e7591e69c1f1838da66aab6cf26b15605'
AND (
token = 'gQmgTtJDiic/IOK1uhIDF507pQPe3ZDVMnnhbqwpCTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)