UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QXYrI3qkc8kIowzwKjPRFwBdEPg48y02xRVVnzlzmc='
WHERE
key_id = '727cbb4788b57c81aa443f87a07a2196033f5c373b2c5489f5747bdeff1c4a8b'
AND (
token = '6QXYrI3qkc8kIowzwKjPRFwBdEPg48y02xRVVnzlzmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)