UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '53Zz9b4G7r0/QFCnDWwMrPvKgTTIEVxH3T+PBLQajdQ=' 
WHERE 
  key_id = 'e858e53e59b62ffc8fc2ec3108c5ba8130017ae305e154aa75b6e9973c189ffa' 
  AND (
    token = '53Zz9b4G7r0/QFCnDWwMrPvKgTTIEVxH3T+PBLQajdQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018