UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K5rss9tj0Cgujuib151Tmcom5HzesZksm4T+aq3YwG0='
WHERE
key_id = 'd219a0d4e8524ff45b734728ee5fb63e713c9423bcb3a947249a9d724b0a8bdd'
AND (
token = 'K5rss9tj0Cgujuib151Tmcom5HzesZksm4T+aq3YwG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)