UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z8S0TvCLLEvBT+mT9BPHfaAStszQdB8Wx8m5wU/6Kgg='
WHERE
key_id = '3e1a3a6e4ab4fd9170a8493a8ca49593aa6d5c23aaba8ad80656409f326a05e2'
AND (
token = 'Z8S0TvCLLEvBT+mT9BPHfaAStszQdB8Wx8m5wU/6Kgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)