UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QxNmxbRmpNfBhzwLmj4eCKPeh/CcS43FfXjwAg2juos='
WHERE
key_id = '9f4b31899c6572aac5609e92d306616b0d2a09f2aa234373526c354637f248f7'
AND (
token = 'QxNmxbRmpNfBhzwLmj4eCKPeh/CcS43FfXjwAg2juos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)