UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I0AtjCaYjSBPNNS+nm3PrR/lDHjxIAlGnGrBeBYAIKE='
WHERE
key_id = 'b1bfca604d1943063178cedc07cba729f001c0fbd25104ac016fc3e8b3044a1d'
AND (
token = 'I0AtjCaYjSBPNNS+nm3PrR/lDHjxIAlGnGrBeBYAIKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)