UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RY8dXe+nRZZiYZVQG5qwUhtg8akCAp+r890FwhNCLh0='
WHERE
key_id = '1e1bf0c24b6c4b9729fc4d158eb6aca06a02af42da0611dd5391da4c3946ff08'
AND (
token = 'RY8dXe+nRZZiYZVQG5qwUhtg8akCAp+r890FwhNCLh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)