UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgtdQtGY9uJQ1M0oMhECir1Z0M8iybBB93p6s5aDDnY='
WHERE
key_id = 'bf9217e7142d0a6b8cda8fb965473c06ce114697d34201e9561f553e5b8e317f'
AND (
token = 'BgtdQtGY9uJQ1M0oMhECir1Z0M8iybBB93p6s5aDDnY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)