UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/QQgfXX315wZfWAAMmh5hyGqfAtGiNxsABVUKBIySgo='
WHERE
key_id = 'c397d9c8ac219bcc1452b28bdc48d6037bf61c13bd1fdb89945a6a03f4bc95ac'
AND (
token = '/QQgfXX315wZfWAAMmh5hyGqfAtGiNxsABVUKBIySgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)