UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k5msjxIH72gvNMpn+1+s49PEXUxTvzdrRIjIAl4KMc4='
WHERE
key_id = 'bbf7375321e6aad8364733d075971ad10ac830e43cb3718afeb7aec526c5ce85'
AND (
token = 'k5msjxIH72gvNMpn+1+s49PEXUxTvzdrRIjIAl4KMc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)