UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KvP5AxvY6ZZ0TdhGC0drE4jxPPidx45ya7N5wwcAANs='
WHERE
key_id = '58612d19c93790c400ca6be447bd49f1fe5c76b8800fc1668a96cf7b577fa304'
AND (
token = 'KvP5AxvY6ZZ0TdhGC0drE4jxPPidx45ya7N5wwcAANs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)