UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8MQVXj3BZSzFuPYecaE2aOGNOwfubXbOmjtLy3gNzE='
WHERE
key_id = '733a027fc9696fb819d7f9769116f42b3a77bcec98a2ea0768ed8ce9cd191d97'
AND (
token = 'S8MQVXj3BZSzFuPYecaE2aOGNOwfubXbOmjtLy3gNzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)