UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uy40SwSGVssA7Rn6OxUGODK5CjF9xOwq3tCpsy9nsUg='
WHERE
key_id = '3c9064d4e583639203efde585ed2cf5ae16bdc58b3bb5b4ead592ea6be32f178'
AND (
token = 'uy40SwSGVssA7Rn6OxUGODK5CjF9xOwq3tCpsy9nsUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)