UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hk7VCkgCAPb4epAzStjNnEWSn9gi6XqHxGsTwhqCXsc='
WHERE
key_id = '0e1c416f01c0217d0ab35f7260f76e19d6b0904d98328382c8576a4912f374fc'
AND (
token = 'Hk7VCkgCAPb4epAzStjNnEWSn9gi6XqHxGsTwhqCXsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)