UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hqgfjIl0A//WkZS/9nN/pYMxxl0+kvn2gZW08aPpegY=' 
WHERE 
  key_id = 'fec1ffe4009a7c5e67b77f1e4634c764cb570b273b9a95948048829e5ac3be88' 
  AND (
    token = 'hqgfjIl0A//WkZS/9nN/pYMxxl0+kvn2gZW08aPpegY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044