UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RWFBBUk3UQJ8pw/vHSTQOnkNZ9VIzsebsTJikEX/5Ms='
WHERE
key_id = 'b8ed0fca9b9cf216b23c608808c34cfd388396a55efdc69e8f5e5030f19c87ea'
AND (
token = 'RWFBBUk3UQJ8pw/vHSTQOnkNZ9VIzsebsTJikEX/5Ms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)